Personal Computer World 2005 October/PCWOCT05.iso/Software/FromTheMag/XAMPP 1.4.14/xampp-win32-1.4.14-installer.exe/xampp/php/pear/adodb/session/adodb-sessions.mysql.sql

Text File | 2003-11-04 | 396b | 17 lines

-- $CVSHeader$

CREATE DATABASE /*! IF NOT EXISTS */ adodb_sessions;

USE adodb_sessions;

DROP TABLE /*! IF EXISTS */ sessions;

CREATE TABLE /*! IF NOT EXISTS */ sessions (
    sesskey        CHAR(32)    /*! BINARY */ NOT NULL DEFAULT '',
    expiry        INT(11)        /*! UNSIGNED */ NOT NULL DEFAULT 0,
    expireref    VARCHAR(64)    DEFAULT '',
    data        LONGTEXT    DEFAULT '',
    PRIMARY KEY    (sesskey),
    INDEX expiry (expiry)
);